{\rtf1\ansi\ansicpg936\uc2\deff0\stshfdbch13\stshfloch0\stshfhich0\stshfbi0\deflang1033\deflangfe2052{\fonttbl{\f0\froman\fcharset0\fprq2{\*\panose 02020603050405020304}Times New Roman;}{\f1\fswiss\fcharset0\fprq2{\*\panose 020b0604020202020204}Arial;}
{\f13\fnil\fcharset134\fprq2{\*\panose 02010600030101010101}\'cb\'ce\'cc\'e5{\*\falt SimSun};}{\f17\fnil\fcharset134\fprq2{\*\panose 02010600030101010101}\'ba\'da\'cc\'e5{\*\falt SimHei};}
{\f36\fnil\fcharset134\fprq2{\*\panose 02010600030101010101}@\'cb\'ce\'cc\'e5;}{\f37\fnil\fcharset134\fprq2{\*\panose 00000000000000000000}@\'ba\'da\'cc\'e5;}{\f39\froman\fcharset238\fprq2 Times New Roman CE;}
{\f40\froman\fcharset204\fprq2 Times New Roman Cyr;}{\f42\froman\fcharset161\fprq2 Times New Roman Greek;}{\f43\froman\fcharset162\fprq2 Times New Roman Tur;}{\f44\froman\fcharset177\fprq2 Times New Roman (Hebrew);}
{\f45\froman\fcharset178\fprq2 Times New Roman (Arabic);}{\f46\froman\fcharset186\fprq2 Times New Roman Baltic;}{\f47\froman\fcharset163\fprq2 Times New Roman (Vietnamese);}{\f49\fswiss\fcharset238\fprq2 Arial CE;}
{\f50\fswiss\fcharset204\fprq2 Arial Cyr;}{\f52\fswiss\fcharset161\fprq2 Arial Greek;}{\f53\fswiss\fcharset162\fprq2 Arial Tur;}{\f54\fswiss\fcharset177\fprq2 Arial (Hebrew);}{\f55\fswiss\fcharset178\fprq2 Arial (Arabic);}
{\f56\fswiss\fcharset186\fprq2 Arial Baltic;}{\f57\fswiss\fcharset163\fprq2 Arial (Vietnamese);}{\f171\fnil\fcharset0\fprq2 SimSun Western{\*\falt SimSun};}{\f401\fnil\fcharset0\fprq2 @\'cb\'ce\'cc\'e5 Western;}}{\colortbl;\red0\green0\blue0;
\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue128;\red0\green128\blue128;\red0\green128\blue0;\red128\green0\blue128;
\red128\green0\blue0;\red128\green128\blue0;\red128\green128\blue128;\red192\green192\blue192;\red0\green51\blue102;\red102\green102\blue153;\red255\green102\blue0;}{\stylesheet{\qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 
\fs21\lang1033\langfe2052\kerning2\loch\f0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 \snext0 Normal;}{\s2\qj \li0\ri0\sb260\sa260\sl416\slmult1\keep\keepn\nowidctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0 
\b\fs32\lang1033\langfe2052\kerning2\loch\f1\hich\af1\dbch\af17\cgrid\langnp1033\langfenp2052 \sbasedon0 \snext0 \styrsid4195702 heading 2;}{
\s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0 \b\fs27\lang1033\langfe2052\loch\f13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 \sbasedon0 \snext3 \styrsid8720988 heading 3;}{
\s4\qj \li0\ri0\sb280\sa290\sl376\slmult1\keep\keepn\nowidctlpar\aspalpha\aspnum\faauto\outlinelevel3\adjustright\rin0\lin0\itap0 \b\fs28\lang1033\langfe2052\kerning2\loch\f1\hich\af1\dbch\af17\cgrid\langnp1033\langfenp2052 
\sbasedon0 \snext0 \styrsid12674676 heading 4;}{\*\cs10 \additive \ssemihidden Default Paragraph Font;}{\*
\ts11\tsrowd\trftsWidthB3\trpaddl108\trpaddr108\trpaddfl3\trpaddft3\trpaddfb3\trpaddfr3\trcbpat1\trcfpat1\tscellwidthfts0\tsvertalt\tsbrdrt\tsbrdrl\tsbrdrb\tsbrdrr\tsbrdrdgl\tsbrdrdgr\tsbrdrh\tsbrdrv 
\ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs20\lang1024\langfe1024\loch\f0\hich\af0\dbch\af13\cgrid\langnp1024\langfenp1024 \snext11 \ssemihidden Normal Table;}{\s15\ql \li0\ri0\widctlpar
\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe2052\loch\f13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 
\sbasedon0 \snext15 \styrsid5983950 HTML Preformatted;}{\*\cs16 \additive \sbasedon10 \styrsid5983950 n;}{\*\cs17 \additive \sbasedon10 \styrsid5983950 p;}{\*\cs18 \additive \sbasedon10 \styrsid5983950 o;}{\*\cs19 \additive \sbasedon10 \styrsid5983950 s;}
{\*\cs20 \additive \ul\cf2 \sbasedon10 \styrsid8720988 Hyperlink;}{\*\cs21 \additive \sbasedon10 \styrsid8720988 pre;}{\*\cs22 \additive \sbasedon10 \styrsid1011018 gp;}{\*\cs23 \additive \sbasedon10 \styrsid1011018 kn;}{\*\cs24 \additive 
\sbasedon10 \styrsid1011018 nn;}{\*\cs25 \additive \sbasedon10 \styrsid1011018 bp;}{\*\cs26 \additive \sbasedon10 \styrsid8404809 k;}{\*\cs27 \additive \sbasedon10 \styrsid8404809 nc;}{\*\cs28 \additive \sbasedon10 \styrsid8404809 nb;}{\*\cs29 \additive 
\sbasedon10 \styrsid8404809 nf;}{\*\cs30 \additive \sbasedon10 \styrsid8404809 si;}{\*\cs31 \additive \sbasedon10 \styrsid8404809 go;}{\*\cs32 \additive \sbasedon10 \styrsid3810732 c;}{\*\cs33 \additive \fs24\loch\f13\hich\af13\dbch\af13 
\sbasedon10 \styrsid10755815 HTML Typewriter;}}{\*\latentstyles\lsdstimax156\lsdlockeddef0}{\*\listtable{\list\listtemplateid1022919554{\listlevel\levelnfc255\levelnfcn255\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\'02\'d2\'bb\'a3\'ae;}{\levelnumbers;}\fbias0 \fi-405\li405\jclisttab\tx405\lin405 }{\listlevel\levelnfc4\levelnfcn4\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'01);}{\levelnumbers\'01;}\fi-420\li840
\jclisttab\tx840\lin840 }{\listlevel\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'02.;}{\levelnumbers\'01;}\fi-420\li1260\jclisttab\tx1260\lin1260 }{\listlevel\levelnfc0\levelnfcn0\leveljc0
\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'03.;}{\levelnumbers\'01;}\fi-420\li1680\jclisttab\tx1680\lin1680 }{\listlevel\levelnfc4\levelnfcn4\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0
{\leveltext\'02\'04);}{\levelnumbers\'01;}\fi-420\li2100\jclisttab\tx2100\lin2100 }{\listlevel\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'05.;}{\levelnumbers\'01;}\fi-420\li2520
\jclisttab\tx2520\lin2520 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'06.;}{\levelnumbers\'01;}\fi-420\li2940\jclisttab\tx2940\lin2940 }{\listlevel\levelnfc4\levelnfcn4\leveljc0
\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\'02\'07);}{\levelnumbers\'01;}\fi-420\li3360\jclisttab\tx3360\lin3360 }{\listlevel\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0
{\leveltext\'02\'08.;}{\levelnumbers\'01;}\fi-420\li3780\jclisttab\tx3780\lin3780 }{\listname ;}\listid1645159011}{\list\listtemplateid-997175580\listhybrid{\listlevel\levelnfc39\levelnfcn39\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid67698711\'03(\'00);}{\levelnumbers\'02;}\fbias0 \fi-420\li420\jclisttab\tx420\lin420 }{\listlevel\levelnfc4\levelnfcn4\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid67698713\'02\'01);}{\levelnumbers\'01;}\fi-420\li840\jclisttab\tx840\lin840 }{\listlevel\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid67698715
\'02\'02.;}{\levelnumbers\'01;}\fi-420\li1260\jclisttab\tx1260\lin1260 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid67698703\'02\'03.;}{\levelnumbers\'01;}\fi-420\li1680
\jclisttab\tx1680\lin1680 }{\listlevel\levelnfc4\levelnfcn4\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid67698713\'02\'04);}{\levelnumbers\'01;}\fi-420\li2100\jclisttab\tx2100\lin2100 }{\listlevel
\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid67698715\'02\'05.;}{\levelnumbers\'01;}\fi-420\li2520\jclisttab\tx2520\lin2520 }{\listlevel\levelnfc0\levelnfcn0\leveljc0\leveljcn0
\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext\leveltemplateid67698703\'02\'06.;}{\levelnumbers\'01;}\fi-420\li2940\jclisttab\tx2940\lin2940 }{\listlevel\levelnfc4\levelnfcn4\leveljc0\leveljcn0\levelfollow0\levelstartat1\levelspace0
\levelindent0{\leveltext\leveltemplateid67698713\'02\'07);}{\levelnumbers\'01;}\fi-420\li3360\jclisttab\tx3360\lin3360 }{\listlevel\levelnfc2\levelnfcn2\leveljc2\leveljcn2\levelfollow0\levelstartat1\levelspace0\levelindent0{\leveltext
\leveltemplateid67698715\'02\'08.;}{\levelnumbers\'01;}\fi-420\li3780\jclisttab\tx3780\lin3780 }{\listname ;}\listid2111315994}}{\*\listoverridetable{\listoverride\listid2111315994\listoverridecount0\ls1}{\listoverride\listid1645159011
\listoverridecount0\ls2}}{\*\pgptbl {\pgp\ipgp9\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp6\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp5\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp2\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp11\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0
\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp12\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp8\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp13\itap0\li0\ri0
\sb0\sa0}{\pgp\ipgp34\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp24\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp51\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp56\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}
{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp18\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp32\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp26\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp48\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0
\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp27\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp52\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp16\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp49\itap0\li0
\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp40\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp36\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp38\itap0\li0\ri0\sb0\sa0}
{\pgp\ipgp22\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp47\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp44\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp54\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp37\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp17\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0
\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp21\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp41\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0
\sb0\sa0}{\pgp\ipgp0\itap0\li0\ri0\sb0\sa0}{\pgp\ipgp55\itap0\li0\ri0\sb0\sa0}}{\*\rsidtbl \rsid1011018\rsid1122475\rsid1666424\rsid1840866\rsid2371858\rsid2373227\rsid2500973\rsid2887906\rsid3019773\rsid3031230\rsid3148551\rsid3234644\rsid3554520
\rsid3810732\rsid4195702\rsid4338433\rsid4522546\rsid4799606\rsid4807204\rsid4987241\rsid5128401\rsid5254912\rsid5663935\rsid5970671\rsid5983950\rsid6759597\rsid7741701\rsid7895510\rsid8205219\rsid8404809\rsid8720988\rsid9600060\rsid10038880\rsid10122781
\rsid10385034\rsid10684168\rsid10755815\rsid11172471\rsid11279581\rsid11349680\rsid11612485\rsid11738090\rsid12674676\rsid12910954\rsid13134732\rsid13643638\rsid14040941\rsid14233130\rsid14811156\rsid14823777\rsid14832437\rsid15016158\rsid15081868
\rsid15667809\rsid15735529}{\*\generator Microsoft Word 11.0.6359;}{\info{\author User}{\operator User}{\creatim\yr2009\mo1\dy20\hr13\min7}{\revtim\yr2009\mo2\dy2\hr10\min39}{\version58}{\edmins152}{\nofpages9}{\nofwords1368}{\nofchars7800}
{\*\company Microsoft}{\nofcharsws9150}{\vern24703}}\paperw12240\paperh15840\margl1800\margr1800\margt1440\margb1440\gutter0 \ftnbj\aenddoc\hyphcaps0\horzdoc\dghspace120\dgvspace120\dghorigin1701\dgvorigin1984\dghshow0\dgvshow3
\jcompress\viewkind1\viewscale100\rsidroot8205219 \fet0\sectd \linex0\sectdefaultcl\sftnbj {\*\pnseclvl1\pnucrm\pnstart1\pnindent720\pnhang {\pntxta \dbch .}}{\*\pnseclvl2\pnucltr\pnstart1\pnindent720\pnhang {\pntxta \dbch .}}{\*\pnseclvl3
\pndec\pnstart1\pnindent720\pnhang {\pntxta \dbch .}}{\*\pnseclvl4\pnlcltr\pnstart1\pnindent720\pnhang {\pntxta \dbch )}}{\*\pnseclvl5\pndec\pnstart1\pnindent720\pnhang {\pntxtb \dbch (}{\pntxta \dbch )}}{\*\pnseclvl6\pnlcltr\pnstart1\pnindent720\pnhang 
{\pntxtb \dbch (}{\pntxta \dbch )}}{\*\pnseclvl7\pnlcrm\pnstart1\pnindent720\pnhang {\pntxtb \dbch (}{\pntxta \dbch )}}{\*\pnseclvl8\pnlcltr\pnstart1\pnindent720\pnhang {\pntxtb \dbch (}{\pntxta \dbch )}}{\*\pnseclvl9\pnlcrm\pnstart1\pnindent720\pnhang 
{\pntxtb \dbch (}{\pntxta \dbch )}}\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bd\'ab\'b1\'ed\'b5\'a5\'d6\'d0\'cb\'f9\'d3\'c3\'b5\'c4\'cb\'f9\'d3\'d0\'d7\'d6\'b6\'ce\'d2\'d4\'d2\'bb\'b8\'f6\'ce\'c4\'bc\'fe\'b4\'e6\'b7\'c5}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da\'c4\'a3\'b0\'e5\'cf\'b5\'cd\'b3}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'d4}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 NAMESPACE }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b5\'bc\'c8\'eb}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d5\'e2\'d1\'f9\'d3\'d0\'ce\'ca\'cc\'e2}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'bb\'d2\'aa\'d0\'de\'b8\'c4\'d7\'d6\'b6\'ce
\'ce\'c4\'bc\'fe\'bc\'b4\'bf\'c9}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 .
\par 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'e7\'b9\'fb\'d2\'fd\'d3\'c3\'c1\'cb}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
@validate(schema=NewPageForm(), form='button')}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'ae\'c0\'e0\'b5\'c4}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 self.form_result.items()}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ca\'c7\'bf\'c9\'d2\'d4
\'d6\'b1\'bd\'d3\'d2\'fd\'d3\'c3\'b5\'c4}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c6\'e4
\'bd\'e1\'b9\'fb\'ca\'c7\'b7\'b5\'bb\'d8\'b5\'b1\'c7\'b0\'ca\'e4\'c8\'eb\'b5\'c4\'d6\'b5}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  
\par \hich\af0\dbch\af13\loch\f13 [('title', u'tgdfgd')]
\par \hich\af0\dbch\af13\loch\f13 form_result = schema.to_python(dict(request.params))
\par 
\par 
\par \hich\af0\dbch\af13\loch\f13   items()}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'d4}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 List}
{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b7\'b5\'bb\'d8}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 Dictionary}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'cb\'f9\'d3\'d0\'cf\'ee\'c4\'bf\'a3\'ac\'c3\'bf\'b8\'f6\'cf\'ee\'c4\'bf\'b5\'c4\'d0\'ce\'ca\'bd\'ca\'c7}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 (key, value):
\par 
\par \hich\af0\dbch\af13\loch\f13 >>> d = \{'title': 'Python Web Site', 'url': 'http://www.python.org', 'spam': 0\}
\par \hich\af0\dbch\af13\loch\f13 >>> d.items()
\par \hich\af0\dbch\af13\loch\f13 [('url', 'http://www.python.org'), ('spam', 0), ('ti\hich\af0\dbch\af13\loch\f13 tle', 'Python Web Site')]
\par 
\par 
\par \hich\af0\dbch\af13\loch\f13  }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ca\'b9\'d3\'c3}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
dict()}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ba\'af\'ca\'fd\'bf\'c9\'d2\'d4\'b4\'d3}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
Mapping}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'a3\'a8\'c8\'e7\'c6\'e4\'cb\'fc\'b5\'c4}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
Dictionary}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'a3\'a9\'bb\'f2}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 key/value}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d0\'ce\'ca\'bd\'b5\'c4}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 Sequence}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b4\'b4\'bd\'a8}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 Dictionary}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'a3\'ba}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 >>> items = [('name', 'Gumby'), ('age', 42)]
\par \hich\af0\dbch\af13\loch\f13 >>> d = dict(items)
\par \hich\af0\dbch\af13\loch\f13 >>> d
\par \{\hich\af0\dbch\af13\loch\f13 'age': 42, 'name': 'Gumby'\}
\par 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bb\'f1\'c8\'a1\'b5\'b1\'c7\'b0\'b5\'c4\'b1\'ed\'c3\'fb}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 for t in meta.metadata.table_iterator(reverse=F\hich\af0\dbch\af13\loch\f13 alse):
\par \hich\af0\dbch\af13\loch\f13         
\par \hich\af0\dbch\af13\loch\f13             return t.name
\par 
\par 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 Authentication and Authorisation}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 1 }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'cf\'c8\'b0\'b2\'d7\'b0}{
\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 :
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  easy_install AuthKit
\par \hich\af0\dbch\af13\loch\f13 2.
\par }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c9\'e8\'d6\'c3}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 AuthKit authentication }{
\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'bc\'e4\'bc\'fe}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{
\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b1\'e0\'bc\'ad}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 config/middleware.py,}{
\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da\'b6\'a5\'b2\'bf\'bc\'d3\'c8\'eb}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 import authkit.authenticate
\par }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 3.}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da}{
\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 StatusCodeRedirect middleware}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b4\'fa\'c2\'eb
\'c7\'b0\'bc\'d3\'c8\'eb}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 app = authkit.authenticate.middleware(app, app_conf)
\par }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 4.authkit }{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d0\'e8\'d2\'aa\'ca\'b9\'d3\'c3
\'d3\'eb}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 SQLAlchemy}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'bb\'c6\'eb\'ca\'b9
\'d3\'c3\'b5\'c4}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13   UsersFromDatabase ,}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'cb\'fc
\'d4\'da}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 authkit.users.sqlalchemy_driver}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0
}{\b\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,
\par }{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b1\'e0\'bc\'ad\'d2\'bb\'cf\'c2}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 development.ini,}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d5\'d2\'b5\'bd}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 [app:main] }{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b2\'bf\'b7\'d6}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{
\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bc\'d3\'c8\'eb\'c8\'e7\'cf\'c2\'b2\'bf\'b7\'d6}{\fs20\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 authkit.setup.enable = true
\par \hich\af0\dbch\af13\loch\f13 authkit.setup.method = form, cookie
\par \hich\af0\dbch\af13\loch\f13 authkit.f\hich\af0\dbch\af13\loch\f13 orm.authenticate.user.type = authkit.users.sqlalchemy_driver:UsersFromDatabase
\par \hich\af0\dbch\af13\loch\f13 authkit.form.authenticate.user.data = simplesite.model
\par \hich\af0\dbch\af13\loch\f13 authkit.cookie.secret = secret string
\par \hich\af0\dbch\af13\loch\f13 authkit.cookie.signoutpath = /signout
\par 
\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d5\'e2\'bd\'ab\'b8\'e6\'cb\'df}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 authkit}{
\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c4\'e3\'bd\'ab\'ca\'b9\'d3\'c3}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 SQLAlchemy 
}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'a5\'b9\'dc\'c0\'ed\'d3\'c3\'bb\'a7}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
,SQLAlchemy model}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bf\'c9\'d2\'d4\'b1\'bb\'b6\'a8\'d2\'e5\'d4\'da}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 simplesite.model module.}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'b5\'c4}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 PYLONS}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c6\'e4\'cb\'fc\'b3\'cc\'d0\'f2\'cb\'f9\'ca\'b9\'d3\'c3}{
\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 5.}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b5\'f7\'d5\'fb}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 websetup.py
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'aa\'c1\'cb\'d6\'a7\'b3\'d6\'d2\'d1\'be\'ad\'bc\'d3\'b7\'c5\'b5\'bd}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 MODEL}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'b5\'c4}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 AUTHKIT ,}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d0\'e8\'d2\'aa\'d0\'c2\'bd\'a8
\'ca\'fd\'be\'dd\'b1\'ed}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da\'b6\'a5\'b2\'bf\'bc\'d3\'c8\'eb}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 from authkit.users.sqlalchemy_driver import UsersFromDatabase
\par \hich\af0\dbch\af13\loch\f13 # Load the models
\par \hich\af0\dbch\af13\loch\f13 from simplesite.model import meta
\par \hich\af0\dbch\af13\loch\f13 meta.metadata.bind = met\hich\af0\dbch\af13\loch\f13 a.engine
\par 
\par \hich\af0\dbch\af13\loch\f13 log.info("Adding the AuthKit model...")
\par \hich\af0\dbch\af13\loch\f13 users = UsersFromDatabase(model)
\par \hich\af0\dbch\af13\loch\f13 meta.metadata.create_all(checkfirst=True)(}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'e7\'b9\'fb\'b2\'bb\'b4\'e6\'d4\'da}{
\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bb\'e1\'b4\'b4\'bd\'a8\'d2\'bb\'b8\'f6}{
\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 )
\par 
\par \hich\af0\dbch\af13\loch\f13 log.info("Adding roles and uses...")
\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'d4\'cf\'c2\'cb\'c4\'d0\'d0\'c9\'e8\'d6\'c3\'c1\'cb\'b3\'cc\'d0\'f2\'cb\'f9\'d0\'e8\'d2\'aa\'b5\'c4\'d3\'c3\'bb\'a7\'ba\'cd\'c8\'a8\'cf\'de}{
\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 users.role_create("delete")
\par \hich\af0\dbch\af13\loch\f13 users.user_create("foo", password="bar")
\par \hich\af0\dbch\af13\loch\f13 users.user_create("admin", password="opensesame")
\par \hich\af0\dbch\af13\loch\f13 users.user_add_role("admin", role="delete"
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  6. paster setup-app development.ini
\par }{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d0\'c2\'ca\'fd\'be\'dd\'b1\'ed\'d7\'d4\'b6\'af\'b4\'b4\'bd\'a8}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par 
\par }{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 The AuthKit }{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'bc\'e4\'bc\'fe
\'d4\'da\'b5\'da\'d2\'bb\'b4\'ce\'c7\'eb\'c7\'f3\'ca\'b1}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\loch\af13\hich\af0\dbch\f13 \'bb\'e1\'d7\'d4\'b6\'af\'d4\'f6\'bc\'d3}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 AuthKit SQLAlchemy model classes  }{
\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b5\'bd}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 SimpleSite'
\hich\af0\dbch\af13\loch\f13 s model ,}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'de\'d0\'e8\'ca\'d6\'b6\'af}{\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 

\par }{\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b1\'a3\'bb\'a4\'bf\'d8\'d6\'c6\'c6\'f7\'b5\'c4\'b6\'af\'d7\'f7}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 

\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 AuthKit }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'aa}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 PAGE}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b5\'c4}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 EDIT}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b6\'af\'d7\'f7\'d4\'f6\'bc\'d3
\'d2\'bb\'b8\'f6\'c8\'a8\'cf\'de}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 
\'ca\'b9\'bd\'f6\'d3\'d0\'b5\'c7\'c8\'eb\'b5\'c4\'d3\'c3\'bb\'a7\'c4\'dc\'b9\'bb\'b1\'e0\'bc\'ad}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'d2\'c3\'c7\'d0\'e8\'d2\'aa\'d4\'da}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 page.py controller}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'d4\'f6\'bc\'d3}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 from authkit.permissions import ValidAuthKitUser
\par \hich\af0\dbch\af13\loch\f13 from authkit.authorize.pylons_adaptors import authorize
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'bb\'ba\'f3\'d4\'da}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 edit() action}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c7\'b0\'d4\'f6\'bc\'d3}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 @authorize(ValidAuthKitUser())
\par \hich\af0\dbch\af13\loch\f13 def edit(self, id=None):
\par 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'aa\'c1\'cb\'d4\'da\'c4\'a3\'bf\'e9\'ca\'b9\'d3\'c3}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'f6\'bc\'d3\'d2\'bb\'b8\'f6\'ce\'c4\'bc\'fe}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 auth.py }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 LIB}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'cf\'c2}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,
\par \hich\af0\dbch\af13\loch\f13 from authkit.permissions import ValidAuthKitUser
\par \hich\af0\dbch\af13\loch\f13 is_valid_user = ValidAuthKitUser()
\par 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'aa\'d4\'da\'d4\'da\'c4\'a3\'b0\'e5\'d2\'b2\'d2\'bb\'d1\'f9\'ca\'b9\'d3\'c3}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'d2\'c3\'c7\'b5\'bc\'c8\'eb
\'d5\'fb\'b8\'f6}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 AUTH }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c4\'a3\'bf\'e9
\'b5\'bd}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  lib/helpers.py,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'f2
\'b4\'cb\'c8\'a8\'cf\'de\'ba\'dc\'c8\'dd\'d2\'d7\'b5\'bd\'d7\'f7\'ce\'aa}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 h.auth.is_valid_user}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ca\'b9\'d3\'c3}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 lib/helpers.py}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b5\'d7\'b2\'bf\'bc\'d3\'c8\'eb}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 from simplesite.lib import auth
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'f2\'b4\'cb\'d4\'da\'c9\'cf\'c3\'e6\'b5\'c4}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 EDIT }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bf\'c9\'d2\'d4\'d0\'de\'b8\'c4\'ce\'aa}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  @authorize(h.auth.is_valid_user)
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b8\'f8\'d3\'c3\'bb\'a7\'d3\'d0
\'c9\'be\'b3\'fd\'b5\'c4\'c8\'a8\'cf\'de}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b1\'e0\'bc\'ad}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 lib/auth.py:
\par \hich\af0\dbch\af13\loch\f13 from authkit.permissions import HasAuthKitRole
\par \hich\af0\dbch\af13\loch\f13 has_delete_role = HasAuthKitRole(['delete'])
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b1\'e0\'bc\'ad}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  delete
\par \hich\af0\dbch\af13\loch\f13 @authorize(h.auth.has_delete_role)
\par \hich\af0\dbch\af13\loch\f13 def delete(self, id=None):
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d5\'e2\'d1\'f9\'bc\'b4\'ca\'b9\'d2\'d1\'be\'ad\'b5\'c7\'c2\'bd\'b5\'c4\'d3\'c3\'bb\'a7}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'e7\'b9\'fb}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c3\'bb\'d3\'d0\'c9\'be\'b3\'fd\'c8\'a8
\'cf\'de}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'b2\'ce\'de\'b7\'a8
\'c9\'be\'b3\'fd}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'bb\'f9\'d3\'da\'c8\'a8\'cf\'de\'b5\'c4\'c4\'a3\'b0\'e5}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c8\'c3\'c3\'bb\'d3\'d0\'b5\'c7\'c2\'bd\'b5\'c4\'d3\'c3\'bb\'a7}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'de\'b7\'a8\'b1\'e0\'bc\'ad\'d2\'b3\'c3\'e6}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'de\'b7\'a8\'cf\'d4\'ca\'be\'b1\'e0
\'bc\'ad\'b5\'c4\'c1\'ac\'bd\'d3}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'da}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 lib/auth.py}{
\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\'bc\'d3\'c8\'eb}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 from authkit.authoirze.pylons_adaptors import authorized
\par 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'d2\'c3\'c7\'d0\'de\'b8\'c4}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 
derived/page/view.html}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c4\'a3\'b0\'e5\'d6\'d0\'b5\'c4}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\hich\af0\dbch\af13\loch\f13 EDIT }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c1\'aa\'bd\'d3}{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 % if h.auth.authorized(h.auth.is_valid_user):
\par \hich\af0\dbch\af13\loch\f13 | <a \hich\af0\dbch\af13\loch\f13 href="$\{h.url_for(controller='page', action='edit', id=c.page.id)\}">Edit Page</a>
\par \hich\af0\dbch\af13\loch\f13 % endif
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b4\'a6\'c0\'ed\'b5\'c7\'c2\'bd\'b5\'c7\'b3\'f6}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d4\'f6\'bc\'d3\'d2\'bb\'b8\'f6\'bf\'d8\'bc\'fe\'c6\'f7}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13  }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 paster controller account
\par \hich\af0\dbch\af13\loch\f13 class AccountController(BaseController):
\par 
\par \hich\af0\dbch\af13\loch\f13     def signin(self):
\par \hich\af0\dbch\af13\loch\f13         if not request.environ.get('REMOTE_USER'):
\par \hich\af0\dbch\af13\loch\f13             # This triggers the AuthKit middleware into displaying the sign in form
\par \hich\af0\dbch\af13\loch\f13             abort(401)
\par \hich\af0\dbch\af13\loch\f13         else:
\par \hich\af0\dbch\af13\loch\f13             return render('/derived/account/signedin.html')
\par 
\par \hich\af0\dbch\af13\loch\f13     def signout(self):
\par \hich\af0\dbch\af13\loch\f13         # The actual removal of the AuthKit cookie \hich\af0\dbch\af13\loch\f13 occurs when the response passes
\par \hich\af0\dbch\af13\loch\f13         # through the AuthKit middleware, we simply need to display a page
\par \hich\af0\dbch\af13\loch\f13         # confirming the user is signed out
\par \hich\af0\dbch\af13\loch\f13         return render('/derived/account/signedout.html')
\par 
\par 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'ce\'d2\'c3\'c7\'d0\'e8\'d2\'aa\'b1\'e0\'bc\'ad\'d2\'bb\'cf\'c2\'c2\'b7\'d3\'c9}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d2\'d4\'b1\'e3}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 /signin}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'c4\'dc\'d6\'b8\'cf\'f2}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 signin() }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'b6\'af\'d7\'f7}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 ,signout() }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \loch\af13\hich\af0\dbch\f13 \'d6\'b8
\loch\af13\hich\af0\dbch\f13 \'cf\'f2}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 \hich\af0\dbch\af13\loch\f13 signout() 
\par 
\par \hich\af0\dbch\af13\loch\f13  config/routing.py:
\par 
\par \hich\af0\dbch\af13\loch\f13 map.connect('signout', '/signout', controller='account', action='signout')
\par \hich\af0\dbch\af13\loch\f13 map.connect('signin', '/signin', controller='account', action='signin')}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \loch\af13\hich\af0\dbch\f13 \'b7\'c3\'ce\'ca\'c1\'d0\'b5\'c4\'bc\'b8\'d6\'d6\'b7\'bd\'ca\'bd\'a3\'ba}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 
\par }{\b\fs20\cf1\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8205219 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 employees = Table('employees', metadata,
\par \hich\af0\dbch\af13\loch\f13     Column('empl\hich\af0\dbch\af13\loch\f13 oyee_id', Integer, primary_key=True),
\par \hich\af0\dbch\af13\loch\f13     Column('employee_name', String(60), nullable=False, key='name'),
\par \hich\af0\dbch\af13\loch\f13     Column('employee_dept', Integer, ForeignKey("departments.department_id"))
\par \hich\af0\dbch\af13\loch\f13 )
\par 
\par }{\b\fs20\cf14\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 # access the column "EMPLOYEE_ID":
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 employees.columns.employee_id
\par 
\par }{\b\fs20\cf14\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 # or just
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 employees.c.employee_id
\par 
\par }{\b\fs20\cf14\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 # via string
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219\charrsid8205219 \hich\af0\dbch\af13\loch\f13 employees.c['employee_id']}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8205219 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5983950 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5983950\charrsid5983950 \hich\af0\dbch\af13\loch\f13 Mapper Configuration}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5983950 
\par 
\par }{\cs16\cf11\insrsid5983950\charrsid5983950 \hich\af0\dbch\af13\loch\f0 include_properties}{\cs16\cf11\insrsid5983950 \loch\af0\hich\af0\dbch\f13 \'a3\'ba\'b0\'fc\'ba\'ac}{\cs16\cf11\insrsid5983950 
\par }{\cs16\cf11\insrsid5983950\charrsid5983950 \hich\af0\dbch\af13\loch\f0 exclude_properties}{\cs16\cf11\insrsid5983950 \loch\af0\hich\af0\dbch\f13 \'a3\'ba\'c5\'c5\'b3\'fd}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5983950 

\par }\pard\plain \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid5983950 
\fs24\lang1033\langfe2052\loch\af13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 {\cs16\insrsid3234644 \hich\af13\dbch\af13\loch\f13 1.}{\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 mapper}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 (}{
\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 User}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 users_table}{\cs17\insrsid5983950 
\hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf11\insrsid5983950\charrsid5983950 \hich\af13\dbch\af13\loch\f13 include_properties}{\cs18\insrsid5983950 \hich\af13\dbch\af13\loch\f13 =}{\cs17\insrsid5983950 
\hich\af13\dbch\af13\loch\f13 [}{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 'user_id'}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 
'user_name'}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ])}{\insrsid5983950 
\par }{\cs16\insrsid3234644 \hich\af13\dbch\af13\loch\f13 2.}{\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 mapper}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 (}{\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 Address}{\cs17\insrsid5983950 
\hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs16\insrsid5983950 \hich\af13\dbch\af13\loch\f13 addresses_table}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{
\cs16\cf11\insrsid5983950\charrsid5983950 \hich\af13\dbch\af13\loch\f13 exclude_properties}{\cs18\insrsid5983950 \hich\af13\dbch\af13\loch\f13 =}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 [}{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 
'street'}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 'city'}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 
\hich\af13\dbch\af13\loch\f13  }{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 'state'}{\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ,}{\insrsid5983950 \hich\af13\dbch\af13\loch\f13  }{\cs19\insrsid5983950 \hich\af13\dbch\af13\loch\f13 'zip'}{
\cs17\insrsid5983950 \hich\af13\dbch\af13\loch\f13 ])}{\cs17\insrsid5983950 
\par }{\cs17\insrsid13643638 
\par }{\cs17\b\insrsid13643638\charrsid13643638 \loch\af13\hich\af13\dbch\f13 \'ca\'b9\'d3\'c3\'b1\'f0\'c3\'fb}{\cs17\b\insrsid13643638\charrsid13643638 
\par }\pard \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13643638 {
\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 mapper}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 (}{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 User}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 users_table}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 properties}{
\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 =}{\cs17\cf10\insrsid13643638\charrsid4799606 \{}{\cf10\insrsid13643638\charrsid4799606 
\par }{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13    }{\cs19\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 'id'}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 :}{
\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 users_table}{\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{
\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 c}{\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 user_id}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 
\par }{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13    }{\cs19\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 'name'}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 :}{
\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 users_table}{\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{
\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 c}{\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 user_name}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 
\par }{\cs17\cf10\insrsid13643638\charrsid4799606 \}}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 )}{\cf10\insrsid13643638\charrsid4799606 
\par }\pard \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid5983950 {\b\insrsid13643638\charrsid13643638 
\loch\af13\hich\af13\dbch\f13 \'b8\'f8\'cb\'f9\'d3\'d0\'b5\'c4\'c1\'d0\'bc\'d3\'d2\'bb\'b8\'f6\'c7\'b0\'d7\'ba}{\b\insrsid13643638\charrsid13643638 
\par }\pard \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13643638 {
\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 mapper}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 (}{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 User}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 users_table}{
\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 column_prefix}{
\cs18\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 =}{\cs19\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 '_'}{\cs17\cf10\insrsid13643638\charrsid4799606 \hich\af13\dbch\af13\loch\f13 )}{
\cf10\insrsid13643638\charrsid4799606 
\par }\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8205219 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5983950 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid13643638 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid13643638 \loch\af13\hich\af0\dbch\f13 \'d1\'d3\'bb\'ba}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10385034 \loch\af13\hich\af0\dbch\f13 \'c1\'d0\'b5\'c4
\'d4\'d8\'c8\'eb}{\cs16\insrsid10385034 \hich\af0\dbch\af13\loch\f0 deferred}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid13643638 
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid10385034 
\fs24\lang1033\langfe2052\loch\af13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 {\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 mapper}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 (}{
\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 Book}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{
\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 book_excerpts}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ,}{\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{
\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 properties}{\cs18\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 =}{\cs17\cf10\insrsid10385034\charrsid4799606 \{}{\cf10\insrsid10385034\charrsid4799606 
\par }{\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13    }{\cs19\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 'excerpt'}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 :}{
\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 deferred}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 (}{
\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 book_excerpts}{\cs18\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 c}{
\cs18\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 excerpt}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 ),}{
\cf10\insrsid10385034\charrsid4799606 
\par }{\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13    }{\cs19\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 'photo'}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 :}{
\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13  }{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 deferred}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 (}{
\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 book_excerpts}{\cs18\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 c}{
\cs18\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 .}{\cs16\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 photo}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 )}{
\cf10\insrsid10385034\charrsid4799606 
\par }{\cs17\cf10\insrsid10385034\charrsid4799606 \}}{\cs17\cf10\insrsid10385034\charrsid4799606 \hich\af13\dbch\af13\loch\f13 )}{\cf10\insrsid10385034\charrsid4799606 
\par }\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8205219 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10385034 

\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606 
\par 
\par 
\par 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1840866 \hich\af0\dbch\af13\loch\f13 SQL }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1840866 \loch\af13\hich\af0\dbch\f13 \'d3\'ef\'c3\'fb\'d7\'f7\'ce\'aa
\'c1\'d0\'b5\'c4\'ca\'f4\'d0\'d4}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1840866 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606 
\par }{\b\fs20\cf17\lang2052\langfe2052\kerning0\highlight7\loch\af13\langnp2052\insrsid4799606\charrsid4799606 \loch\af13\hich\af0\dbch\f13 \'bd\'ab\'c1\'bd\'b8\'f6\'d7\'d6\'b6\'ce\'ba\'cf\'b2\'a2\'b3\'c9\'d2\'bb\'b8\'f6}{
\b\fs20\cf17\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606\charrsid4799606 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid4799606 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606\charrsid4799606 \hich\af0\dbch\af13\loch\f13 mapper(User, users_table, properties=\{
\par \hich\af0\dbch\af13\loch\f13     'fullname': column_property(
\par \hich\af0\dbch\af13\loch\f13         (users_table.c.firstname + " " + users_table.c.lastname).label('fullname')
\par \hich\af0\dbch\af13\loch\f13     )
\par \}\hich\af0\dbch\af13\loch\f13 )
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606\charrsid4799606 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8205219 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606 
\par }{\b\fs20\cf17\lang2052\langfe2052\kerning0\highlight7\loch\af13\langnp2052\insrsid4799606\charrsid4799606 \loch\af13\hich\af0\dbch\f13 \'cd\'b3\'bc\'c6\'a3\'ba}{
\b\fs20\cf17\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606\charrsid4799606 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid4799606 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4799606\charrsid4799606 \hich\af0\dbch\af13\loch\f13 mapper(User, users_table, properties=\{
\par \hich\af0\dbch\af13\loch\f13     'address_count': column_property(
\par \hich\af0\dbch\af13\loch\f13             select(
\par \hich\af0\dbch\af13\loch\f13                 [func.count(addresses_table.c.address_id)],
\par \hich\af0\dbch\af13\loch\f13                 addresses_table.c.user_id==users_table.c.user_id
\par \hich\af0\dbch\af13\loch\f13             ).label('address_count')
\par \hich\af0\dbch\af13\loch\f13         )
\par \}\hich\af0\dbch\af13\loch\f13 )
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5970671 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid8720988 \b\fs27\lang1033\langfe2052\loch\af13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 {
\cf6\insrsid8720988\charrsid8720988 \hich\af13\dbch\af13\loch\f13 Controlling Ordering}{\cf6\insrsid8720988\charrsid8720988 \loch\af13\hich\af13\dbch\f13 \uc1\u182\'3f}{\cf6\insrsid8720988 
\par }{\cf6\insrsid8720988\charrsid8720988 \hich\af13\dbch\af13\loch\f13 mapper(Address, addresses_table)
\par 
\par }\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8720988 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {
\b\fs20\cf10\lang2052\langfe2052\kerning0\highlight7\loch\af13\langnp2052\insrsid8720988\charrsid8720988 \hich\af0\dbch\af13\loch\f13 # order address objects by address id}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988\charrsid8720988 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988\charrsid8720988 \hich\af0\dbch\af13\loch\f13 mapper(User, users_table, properties=\{
\par \hich\af0\dbch\af13\loch\f13     'addresses': relation(Address, order_by=addresses_table.c.address_id)
\par }\pard \ql \li0\ri0\nowidctlpar\tx915\faauto\rin0\lin0\itap0\pararsid11612485 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988\charrsid8720988 \}}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988\charrsid8720988 \hich\af0\dbch\af13\loch\f13 )}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11612485 \tab }{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8720988\charrsid8720988 
\par }\pard\plain \s3\ql \li0\ri0\sb100\sa100\sbauto1\saauto1\widctlpar\aspalpha\aspnum\faauto\outlinelevel2\adjustright\rin0\lin0\itap0\pararsid8720988 \b\fs27\lang1033\langfe2052\loch\af13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 {
\cf6\insrsid8720988\charrsid8720988 
\par }\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid4799606 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\highlight7\insrsid8720988\charrsid15667809 \loch\af0\hich\af0\dbch\f13 \'ce\'aa
\'c1\'cb\'d4\'da}{\highlight7\insrsid15667809\charrsid15667809 \loch\af0\hich\af0\dbch\f13 \'b2\'e9\'d1\'af\'b2\'e3\'b5\'c4\'b9\'d8\'cf\'b5\'b1\'ed\'d6\'ae\'bc\'e4\'bf\'d8\'d6\'c6\'c5\'c5\'d0\'f2\'a3\'ac\'bf\'c9\'d2\'d4\'d3\'c3}{
\cs21\highlight7\insrsid15667809\charrsid15667809 \hich\af0\dbch\af13\loch\f0 join()}{\cs21\insrsid8720988 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid14811156 {
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14811156\charrsid14811156 \hich\af0\dbch\af13\loch\f13 session.query(User).join('addresses').order_by(Address.street)
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid4799606 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid15667809 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid10684168 {\b\fs20\cf10\lang2052\langfe2052\kerning0\highlight7\loch\af13\langnp2052\insrsid10684168\charrsid10684168 \hich\af0\dbch\af13\loch\f13 # order by a column}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168\charrsid10684168 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168\charrsid10684168 \hich\af0\dbch\af13\loch\f13 mapper(User, users_table, order_by=users_table.c.user_id)
\par 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\highlight7\loch\af13\langnp2052\insrsid10684168\charrsid10684168 \hich\af0\dbch\af13\loch\f13 # order by multiple items}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168\charrsid10684168 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168\charrsid10684168 \hich\af0\dbch\af13\loch\f13 mapper(User, users_table,o}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168 
\hich\af0\dbch\af13\loch\f13 rder_by=[users_table.c.user_id,}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168\charrsid10684168 \hich\af0\dbch\af13\loch\f13 users_table.c.user_name.desc()])
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10684168 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424 
\par 
\par 
\par 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid1666424 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid12910954\charrsid1122475 \loch\af13\hich\af0\dbch\f13 \'d2\'bb\'b4\'ce\'c1\'ac\'bd\'d3\'b6\'e0\'b8\'f6\'ca\'fd\'be\'dd\'bf\'e2}{
\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 
\par }{\b\fs24\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 
\par }{\b\fs24\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 \hich\af0\dbch\af13\loch\f13 engine1 = create_engine('postgres://db1')
\par \hich\af0\dbch\af13\loch\f13 engine2 = create_engine('postgres://db2')
\par }{\b\fs24\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 
\par }{\b\fs24\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 \hich\af0\dbch\af13\loch\f13 Session = sessionmaker(twophase=True)
\par 
\par \hich\af0\dbch\af13\loch\f13 # bind User operations to engine 1, Account operations to engine 2
\par \hich\af0\dbch\af13\loch\f13 Session.configure(binds=\{User:engine1, Account:engine2\})
\par 
\par \hich\af0\dbch\af13\loch\f13 session = Session()
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1666424\charrsid1122475 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 
\par 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 \loch\af13\hich\af0\dbch\f13 \'ca\'fd\'be\'dd\'bf\'e2}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 
\hich\af0\dbch\af13\loch\f13 engine}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 \loch\af13\hich\af0\dbch\f13 \'d1\'a1\'cf\'ee}{
\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid3554520 {\b\fs24\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 \hich\af0\dbch\af13\loch\f13 
db = create_engine('postgres://...', encoding='latin1', echo=True)
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid1666424 {\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3554520\charrsid1122475 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid1122475 
\par 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid6759597 {\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid1122475 \loch\af13\hich\af0\dbch\f13 \'c0\'fb\'d3\'c3}{
\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid1122475 \hich\af0\dbch\af13\loch\f13 engine}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid1122475 \loch\af13\hich\af0\dbch\f13 
\'bf\'c9\'bf\'ec\'cb\'d9\'b2\'e9\'d1\'af\'ca\'fd\'be\'dd\'bf\'e2}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid1122475 
\par }{\b\fs24\cf18\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597\charrsid2373227 \hich\af0\dbch\af13\loch\f13 connection = engine.connect()
\par \hich\af0\dbch\af13\loch\f13 result = connection.execute("select username from users")
\par \hich\af0\dbch\af13\loch\f13 for row in result:
\par \hich\af0\dbch\af13\loch\f13     print "username:", row['username']
\par \hich\af0\dbch\af13\loch\f13 connection.close()
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid6759597 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7895510 
\par 
\par 
\par 
\par 
\par 
\par 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4807204 
\par }\pard\plain \s2\qj \li0\ri0\sb260\sa260\sl416\slmult1\keep\keepn\nowidctlpar\aspalpha\aspnum\faauto\outlinelevel1\adjustright\rin0\lin0\itap0\pararsid4195702 \b\fs32\lang1033\langfe2052\kerning2\loch\af1\hich\af1\dbch\af17\cgrid\langnp1033\langfenp2052 {
\fs24\cf19\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4807204\charrsid4195702 \loch\af13\hich\af1\dbch\f17 \'a1\'b6\'a1\'b6}{\cf19\insrsid4195702\charrsid4195702 \hich\af1\dbch\af17\loch\f1 Relation Configuration}{\field{\*\fldinst {
\cf19\insrsid4195702\charrsid4195702 \hich\af1\dbch\af17\loch\f1  \hich\af1\dbch\af17\loch\f1 HYPERLINK "http://www.sqlalchemy.org/docs/05/mappers.html" \\l "relation-configuration" \\o "Permalink to this headline" }{
\cf19\insrsid11172471\charrsid14823777 {\*\datafield 
18d0c9ea79f9bace118c8200aa004ba90b020000000b000000e0c9ea79f9bace118c8200aa004ba90b5e00000068007400740070003a002f002f007700770077002e00730071006c0061006c006300680065006d0079002e006f00720067002f0064006f00630073002f00300035002f006d00610070007000650072007300
2e00680074006d006c00000017000000720065006c006100740069006f006e002d0063006f006e00660069006700750072006100740069006f006e000000}}}{\fldrslt {\cs20\b0\fs21\ul\cf2\loch\af0\hich\af0\dbch\af13\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f0 
http://www.sqlalchemy.org/docs/05/mappers.html - relation-configuration}}}{\fs24\cf19\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4807204\charrsid4195702 \loch\af13\hich\af1\dbch\f17 \'b9\'d8\'cf\'b5\'a1\'b7\'a1\'b7}{
\fs24\cf19\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid4807204\charrsid4195702 
\par }\pard\plain \s4\qj \li0\ri0\sb280\sa290\sl376\slmult1\keep\keepn\nowidctlpar\aspalpha\aspnum\faauto\outlinelevel3\adjustright\rin0\lin0\itap0\pararsid12674676 \b\fs28\lang1033\langfe2052\kerning2\loch\af1\hich\af1\dbch\af17\cgrid\langnp1033\langfenp2052 
{\insrsid12674676 \hich\af1\dbch\af17\loch\f1 One To Many}{\insrsid12674676\charrsid12674676 \loch\af1\dbch\af17\hich\f1 \'b6}{\insrsid12674676 
\par }\pard\plain \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid6759597 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\insrsid4338433 \loch\af0\hich\af0\dbch\f13 \'d2\'bb\'b6\'d4\'b6\'e0\'b5\'c4\'b9\'d8
\'cf\'b5\'ca\'c7\'b2\'ce\'d5\'d5}{\insrsid4338433 \hich\af0\dbch\af13\loch\f0  }{\insrsid4338433 \loch\af0\hich\af0\dbch\f13 \'b8\'b8\'b1\'ed\'d4\'da\'d7\'d3\'b1\'ed\'d6\'d0\'b7\'c5\'d6\'c3\'d2\'bb\'b8\'f6\'cd\'e2\'bc\'fc\'a3\'ac}{\insrsid4338433 
\hich\af0\dbch\af13\loch\f0 SQLAlchemy}{\insrsid4338433 \loch\af0\hich\af0\dbch\f13 \'d2\'d4}{\insrsid4338433 \hich\af0\dbch\af13\loch\f0 collection}{\insrsid4338433 \loch\af0\hich\af0\dbch\f13 \'b4\'b4\'bd\'a8\'b9\'d8\'cf\'b5\'d4\'da\'b8\'b8\'b1\'ed
\'c9\'cf\'a3\'ac\'b2\'a2\'b0\'fc\'ba\'ac\'d7\'d3\'c0\'e0\'b5\'c4\'ca\'b5\'c0\'fd\'a1\'a3}{\insrsid3019773\charrsid3019773 \loch\af0\hich\af0\dbch\f13 \'ce\'aa\'bd\'a8\'c1\'a2\'cb\'ab\'cf\'f2\'b9\'d8\'cf\'b5\'a3\'ac\'d0\'eb\'d6\'b8\'b6\'a8}{
\insrsid3019773\charrsid3019773 \hich\af0\dbch\af13\loch\f0 backref}{\insrsid13134732 
\par }{\lang1024\langfe1024\noproof\insrsid11172471 {\shp{\*\shpinst\shpleft0\shptop0\shpright9141\shpbottom4624\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz0\shplid1026
{\sp{\sn shapeType}{\sv 202}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 65536}}{\sp{\sn fillColor}{\sv 12632256}}{\sp{\sn fRecolorFillAsPicture}{\sv 0}}
{\sp{\sn fUseShapeAnchor}{\sv 0}}{\sp{\sn fFilled}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar
\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13134732 
\fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 parent_table}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 
\hich\af13\dbch\af13\loch\f13  = Table('parent', metad\hich\af13\dbch\af13\loch\f13 ata,
\par \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True))
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 child_table}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13  = Table('child', metadata,
\par \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),
\par \hich\af13\dbch\af13\loch\f13     Column('parent_id', Integer, }{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid14040941 \hich\af13\dbch\af13\loch\f13 ForeignKey(}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 
'parent.id')))
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 class Parent(object):
\par }{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13     pass
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 class Child(object):
\par }{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13     pass
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid5254912 \hich\af13\dbch\af13\loch\f13 mapper}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 (Parent, parent_table, properties=\{
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid15016158 {
\kerning0\insrsid13134732\charrsid13134732 \hich\af0\dbch\af13\loch\f0    }{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid15016158 \hich\af13\dbch\af13\loch\f13  'children': relation(Child}{\f13\fs18\cf6\kerning0\insrsid15016158\charrsid15016158 
\hich\af13\dbch\af13\loch\f13  , backref='parent'}{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid15016158 \hich\af13\dbch\af13\loch\f13 )}{\kerning0\insrsid13134732\charrsid14040941 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13134732 {
\fs18\kerning0\loch\af13\insrsid13134732\charrsid13134732 \}}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 )
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid5254912 \hich\af13\dbch\af13\loch\f13 mapper}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 (Child, child_table)
\par }\pard \qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\fs18\insrsid13134732\charrsid13134732 
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8192\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar
\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13134732 
\fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 parent_table}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 
\hich\af13\dbch\af13\loch\f13  = Table('parent', metad\hich\af13\dbch\af13\loch\f13 ata,
\par \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True))
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 child_table}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13  = Table('child', metadata,
\par \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),
\par \hich\af13\dbch\af13\loch\f13     Column('parent_id', Integer, }{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid14040941 \hich\af13\dbch\af13\loch\f13 ForeignKey(}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 
'parent.id')))
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 class Parent(object):
\par }{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13     pass
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 class Child(object):
\par }{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13     pass
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid5254912 \hich\af13\dbch\af13\loch\f13 mapper}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 (Parent, parent_table, properties=\{
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid15016158 {
\kerning0\insrsid13134732\charrsid13134732 \hich\af0\dbch\af13\loch\f0    }{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid15016158 \hich\af13\dbch\af13\loch\f13  'children': relation(Child}{\f13\fs18\cf6\kerning0\insrsid15016158\charrsid15016158 
\hich\af13\dbch\af13\loch\f13  , backref='parent'}{\f13\fs18\cf6\kerning0\insrsid13134732\charrsid15016158 \hich\af13\dbch\af13\loch\f13 )}{\kerning0\insrsid13134732\charrsid14040941 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid13134732 {
\fs18\kerning0\loch\af13\insrsid13134732\charrsid13134732 \}}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 )
\par 
\par }{\f13\fs18\cf11\kerning0\insrsid13134732\charrsid5254912 \hich\af13\dbch\af13\loch\f13 mapper}{\f13\fs18\kerning0\insrsid13134732\charrsid13134732 \hich\af13\dbch\af13\loch\f13 (Child, child_table)
\par }\pard \qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 {\fs18\insrsid13134732\charrsid13134732 
\par }}\dpx0\dpy0\dpxsize9141\dpysize4624\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr192\dpfillbgcg192\dpfillbgcb192\dpfillpat1\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{
\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid13134732 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid13134732\charrsid11349680 
\par }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680\charrsid11349680 \loch\af13\hich\af0\dbch\f13 \'bc\'b6\'c1\'aa\'a3\'ba}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680 
\loch\af13\hich\af0\dbch\f13 \'bf\'c9\'d3\'c3\'b5\'c4\'d6\'b5}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680 \hich\af0\dbch\af13\loch\f13  }{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680 
\loch\af13\hich\af0\dbch\f13 \'a3\'ba}{\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 all}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , }{\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 delete}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , }{
\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 save-update}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , }{\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 refresh-expire}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , }{\cs21\insrsid11349680 
\hich\af0\dbch\af13\loch\f0 merge}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , }{\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 expunge}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 , and }{\cs21\insrsid11349680 \hich\af0\dbch\af13\loch\f0 
delete-orphan}{\insrsid11349680 \hich\af0\dbch\af13\loch\f0 .}{\b\fs24\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680\charrsid11349680 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid10755815 \loch\af13\hich\af0\dbch\f13 \'c8\'b1\'ca\'a1\'b5\'c4\'ca\'c7}{\cs21\insrsid10755815 \hich\af0\dbch\af13\loch\f0 save-update,}{\cs33\f13\fs24\insrsid10755815 
\hich\af13\dbch\af13\loch\f13  }{\cs21\insrsid10755815 \hich\af0\dbch\af13\loch\f0 merge}{\insrsid10755815 \hich\af0\dbch\af13\loch\f0 .}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680\charrsid11349680 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid11349680 {
\f13\fs24\cf10\kerning0\insrsid11349680\charrsid11349680 \hich\af13\dbch\af13\loch\f13 mapper(Order, \hich\af13\dbch\af13\loch\f13 order_table, properties=\{
\par \hich\af13\dbch\af13\loch\f13     'items' : relation(Item, items_table, cascade="all, delete-orphan"),
\par \hich\af13\dbch\af13\loch\f13     'customer' : relation(User, users_table, user_orders_table, cascade="save-update"),
\par \}\hich\af13\dbch\af13\loch\f13 )
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid6759597 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par }{\b\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11349680\charrsid10755815 \loch\af13\hich\af0\dbch\f13 \'b4\'cb\'d3\'b3\'c9\'e4\'d6\'b8\'b6\'a8\'c1\'cb\'c1\'bd\'b8\'f6\'b9\'d8\'cf\'b5\'b1\'ed}{
\f13\cf10\kerning0\insrsid11349680\charrsid10755815 \hich\af13\dbch\af13\loch\f13 items}{\f13\cf10\kerning0\insrsid11349680\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'a3\'ac}{\f13\cf10\kerning0\insrsid11349680\charrsid10755815 
\hich\af13\dbch\af13\loch\f13 customer}{\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'a3\'ac\'c6\'e4\'d6\'d0}{\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \hich\af13\dbch\af13\loch\f13 ITEM }{
\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'d6\'b8\'b6\'a8\'c1\'cb}{\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \hich\af13\dbch\af13\loch\f13 all, delete-orphan}{
\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'d7\'f7\'ce\'aa\'cb\'fc\'b5\'c4\'bc\'b6\'c1\'aa\'b7\'bd\'ca\'bd\'a3\'ac\'d5\'e2\'cb\'b5\loch\af13\hich\af13\dbch\f13 \'c3\'f7\'d4\'da\'c6\'e4\'c9\'cf\'bc\'b6}{
\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \hich\af13\dbch\af13\loch\f13 ORDER }{\f13\cf10\kerning0\insrsid14233130\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'cb\'f9\'d7\'f6\'b5\'c4\'cb\'f9\'d3\'d0\'b2\'d9\'d7\'f7\'cd\'ac\'d1\'f9\'d2\'b2
\'d7\'f7\'d3\'c3\'d3\'da\'cb\'fc}{\f13\cf10\kerning0\insrsid15735529\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'a3\'ac\'bc\'d3\'c9\'cf}{\cf10\insrsid15735529\charrsid10755815 \hich\af0\dbch\af13\loch\f0 he }{
\cs21\cf10\insrsid15735529\charrsid10755815 \hich\af0\dbch\af13\loch\f0 delete-orphan}{\cs21\cf10\insrsid15735529\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'d5\'e2\'b8\'f6\'bc\'b6\'c1\'aa\'d6\'b5}{\cs21\cf10\insrsid15735529\charrsid10755815 
\hich\af0\dbch\af13\loch\f0  }{\cs21\cf10\insrsid15735529\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'a3\'ac\'cb\'b5\'c3\'f7\'c8\'e7\'b9\'fb}{\cs21\cf10\insrsid15735529\charrsid10755815 \hich\af0\dbch\af13\loch\f0 ITEM }{
\cs21\cf10\insrsid15735529\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'ba\'cd}{\cs21\cf10\insrsid15735529\charrsid10755815 \hich\af0\dbch\af13\loch\f0 ORDER }{\cs21\cf10\insrsid15735529\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'b2\'bb\'d4\'d9
\'cf\'e0\'b9\'d8}{\cs21\cf10\insrsid3148551\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'a3\'ac\'cb\'fc\'d2\'b2\'d3\'a6\'b5\'b1\'b1\'bb\'c9\'be\'b3\'fd}{\cs21\cf10\insrsid2500973\charrsid10755815 \loch\af0\hich\af0\dbch\f13 \'a1\'a3}{
\cs21\cf10\insrsid7741701\charrsid10755815 
\par }{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \hich\af13\dbch\af13\loch\f13 Customer}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'d6\'b8\'b6\'a8\'c1\'cb}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 
\hich\af13\dbch\af13\loch\f13 save-update}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'b5\'c4\'bc\'b6\'c1\'aa\'d6\'b5}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \hich\af13\dbch\af13\loch\f13  }{
\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'a3\'ac\'b1\'ed\'c3\'f7\'cb\'fc\'b3\'fd\'c1\'cb}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \hich\af13\dbch\af13\loch\f13 ADD}{
\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'cd\'e2\'a3\'ac\'cb\'fc\'bd\'ab\'b2\'bb\'d3\'eb}{\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \hich\af13\dbch\af13\loch\f13 ORDER }{
\f13\cf10\kerning0\insrsid2500973\charrsid10755815 \loch\af13\hich\af13\dbch\f13 \'bc\'b6\'c1\'aa}{\b\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid2500973\charrsid10755815 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par 
\par 
\par }\pard\plain \s15\ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid2887906 
\fs24\lang1033\langfe2052\loch\af13\hich\af13\dbch\af13\cgrid\langnp1033\langfenp2052 {\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid2887906 \loch\af13\hich\af13\dbch\f13 \'c8\'e7\'b9\'fb\'bc\'d3\'d2\'bb\'b8\'f6\'b2\'ce\'ca\'fd}{
\cf10\insrsid2887906\charrsid2887906 \hich\af13\dbch\af13\loch\f13 uselist=False}{\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid2887906 \loch\af13\hich\af13\dbch\f13 \'a3\'ac\'be\'cd\'b1\'e4\'b3\'c9\'c1\'cb}{
\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid2887906 \hich\af13\dbch\af13\loch\f13 ONE TO ONE 
\par }{\cf10\insrsid2887906\charrsid2887906 \hich\af13\dbch\af13\loch\f13 mapper(Parent, parent_table, properties=\{
\par }\pard\plain \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid2887906 
\fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\f13\fs24\cf10\kerning0\insrsid2887906\charrsid2887906 \hich\af13\dbch\af13\loch\f13     'child': relation(Child, uselist=False\hich\af13\dbch\af13\loch\f13 
, backref='parent')
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid7895510 {
\fs24\cf10\kerning0\loch\af13\insrsid2887906\charrsid2887906 \}}{\f13\fs24\cf10\kerning0\insrsid2887906\charrsid2887906 \hich\af13\dbch\af13\loch\f13 )}{\fs24\cf10\kerning0\loch\af13\insrsid7741701\charrsid7895510 
\par }\pard\plain \s4\qj \li0\ri0\sb280\sa290\sl376\slmult1\keep\keepn\nowidctlpar\aspalpha\aspnum\faauto\outlinelevel3\adjustright\rin0\lin0\itap0\pararsid9600060 \b\fs28\lang1033\langfe2052\kerning2\loch\af1\hich\af1\dbch\af17\cgrid\langnp1033\langfenp2052 {
\lang1024\langfe1024\noproof\insrsid11172471 {\shp{\*\shpinst\shpleft-219\shptop807\shpright8901\shpbottom5487\shpfhdr0\shpbxcolumn\shpbxignore\shpbypara\shpbyignore\shpwr3\shpwrk0\shpfblwtxt0\shpz1\shplid1027
{\sp{\sn shapeType}{\sv 202}}{\sp{\sn fFlipH}{\sv 0}}{\sp{\sn fFlipV}{\sv 0}}{\sp{\sn lTxid}{\sv 131072}}{\sp{\sn fillColor}{\sv 12632256}}{\sp{\sn fRecolorFillAsPicture}{\sv 0}}
{\sp{\sn fUseShapeAnchor}{\sv 0}}{\sp{\sn fFilled}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}{\sp{\sn fLayoutInCell}{\sv 1}}{\shptxt \pard\plain \ql \li0\ri0\widctlpar
\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9600060 
\fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 parent_table = Table('parent', metadata,}{
\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('child_id', Integer, ForeignKey('child.id')))}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 child_table = Table('child', metadata,}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     )}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 class Parent(object):}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     pass}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 class Child(object):}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     pass}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 mapper(Parent, parent_table, properties=\{}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     'child': relation(Child)}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \}\hich\af13\dbch\af13\loch\f13 )}{\fs18\kerning0\loch\af13\insrsid9600060\charrsid9600060 
\par }{\f13\fs24\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 mapper(Child, child_table)
\par }\pard \qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9600060 {\fs18\insrsid9600060\charrsid13134732 
\par }}}{\shprslt{\*\do\dobxcolumn\dobypara\dodhgt8193\dptxbx\dptxlrtb{\dptxbxtext\pard\plain \ql \li0\ri0\widctlpar
\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9600060 
\fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 parent_table = Table('parent', metadata,}{
\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('child_id', Integer, ForeignKey('child.id')))}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 child_table = Table('child', metadata,}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     Column('id', Integer, primary_key=True),}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     )}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 class Parent(object):}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     pass}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 class Child(object):}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     pass}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 mapper(Parent, parent_table, properties=\{}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13     'child': relation(Child)}{\f13\fs18\kerning0\insrsid9600060\charrsid9600060 
\par }{\b\f13\fs18\kerning0\insrsid9600060\charrsid9600060 \}\hich\af13\dbch\af13\loch\f13 )}{\fs18\kerning0\loch\af13\insrsid9600060\charrsid9600060 
\par }{\f13\fs24\kerning0\insrsid9600060\charrsid9600060 \hich\af13\dbch\af13\loch\f13 mapper(Child, child_table)
\par }\pard \qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9600060 {\fs18\insrsid9600060\charrsid13134732 
\par }}\dpx-219\dpy807\dpxsize9120\dpysize4680\dpfillfgcr255\dpfillfgcg255\dpfillfgcb255\dpfillbgcr192\dpfillbgcg192\dpfillbgcb192\dpfillpat1\dplinew15\dplinecor0\dplinecog0\dplinecob0}}}}{\insrsid9600060 \hich\af1\dbch\af17\loch\f1 Many To One}{
\insrsid9600060 \loch\af1\hich\af1\dbch\f17 \'a3\'a8}{\cf10\insrsid9600060\charrsid9600060 \loch\af1\hich\af1\dbch\f17 \'d4\'da\'b8\'b8\'b1\'ed\'c9\'cf\'bc\'d3\'cd\'e2\'bc\'fc}{\insrsid9600060 \loch\af1\hich\af1\dbch\f17 \'a3\'a9}{\insrsid9600060 
\par }\pard\plain \qj \li0\ri0\nowidctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid9600060 \fs21\lang1033\langfe2052\kerning2\loch\af0\hich\af0\dbch\af13\cgrid\langnp1033\langfenp2052 {\insrsid9600060 
\par }{\insrsid9600060\charrsid9600060 
\par 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid6759597 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par 
\par 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid5128401 
\par 
\par 
\par 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7895510 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid1011018 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'d2\'bb\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid1011018 {
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018 \loch\af13\hich\af0\dbch\f13 \'b4\'b4\'bd\'a8\'c1\'ac\'bd\'d3}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid1011018 {
\f13\fs24\cf10\kerning0\insrsid1011018\charrsid1011018 \hich\af13\dbch\af13\loch\f13 >>> from sqlalchemy import create_engine
\par \hich\af13\dbch\af13\loch\f13 >>> engine = create_engine('sqlite:///:memory:', echo=True)
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid1011018 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid7741701 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'b6\'fe\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid1011018 {
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 \loch\af13\hich\af0\dbch\f13 \'b6\'a8\'d2\'e5\'b4\'b4\'bd\'a8\'ca\'fd\'be\'dd\'b1\'ed}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid7741701 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid1011018 {
\f13\fs24\cf10\kerning0\insrsid1011018\charrsid1011018 \hich\af13\dbch\af13\loch\f13 >>> from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
\par \hich\af13\dbch\af13\loch\f13 >>> metadata = MetaData()
\par \hich\af13\dbch\af13\loch\f13 >>> users_table = Table('users', metadata,
\par \hich\af13\dbch\af13\loch\f13 ...     Column('id', Integer, prim\hich\af13\dbch\af13\loch\f13 ary_key=True),
\par \hich\af13\dbch\af13\loch\f13 ...     Column('name', String),
\par \hich\af13\dbch\af13\loch\f13 ...     Column('fullname', String),
\par \hich\af13\dbch\af13\loch\f13 ...     Column('password', String)
\par \hich\af13\dbch\af13\loch\f13 ... )
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid1011018 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018 \hich\af0\dbch\af13\loch\f13     
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid1011018 {
\f13\fs24\cf10\kerning0\insrsid1011018\charrsid1011018 \hich\af13\dbch\af13\loch\f13    metadata.create_all(engine)}{\fs24\cf10\kerning0\loch\af13\insrsid1011018 
\par 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid1011018\charrsid1011018 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'c8\'fd\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar
\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid1011018 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018\charrsid1011018 \loch\af13\hich\af0\dbch\f13 \'b6\'a8\'d2\'e5\'d2\'aa\'d3\'b3\'c9\'e4\'b5\'c4\'c0\'e0}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid8404809 {
\f13\fs24\cf10\kerning0\insrsid8404809\charrsid8404809 \hich\af13\dbch\af13\loch\f13 >>> class User(object):
\par \hich\af13\dbch\af13\loch\f13 ...     def __init__(self, name, fullname, password):
\par \hich\af13\dbch\af13\loch\f13 ... \hich\af13\dbch\af13\loch\f13         self.name = name
\par \hich\af13\dbch\af13\loch\f13 ...         self.fullname = fullname
\par \hich\af13\dbch\af13\loch\f13 ...         self.password = password
\par \hich\af13\dbch\af13\loch\f13 ...
\par \hich\af13\dbch\af13\loch\f13 ...     def __repr__(self):
\par \hich\af13\dbch\af13\loch\f13 ...        return "<User('%s','%s', '%s')>" % (self.name, self.fullname, self.password)
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8404809 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 
\par 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid8404809 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'cb\'c4\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid1011018 {
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 \loch\af13\hich\af0\dbch\f13 \'c9\'e8\'d6\'c3\'d3\'b3\'c9\'e4}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid8404809 {
\f13\fs24\cf10\kerning0\insrsid8404809\charrsid8404809 \hich\af13\dbch\af13\loch\f13  from sqlalchemy.orm \hich\af13\dbch\af13\loch\f13 import mapper
\par \hich\af13\dbch\af13\loch\f13  mapper(User, users_table) 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8404809 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid14832437 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'ce\'e5\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid1011018 {
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14832437 \loch\af13\hich\af0\dbch\f13 \'b4\'b4\'bd\'a8\'bb\'e1\'bb\'b0}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid11279581 {
\f13\fs24\cf10\kerning0\insrsid11279581\charrsid11279581 \hich\af13\dbch\af13\loch\f13 from sqlalchemy.orm import sessionmaker
\par \hich\af13\dbch\af13\loch\f13 Session = sessionmaker(bind=engine)
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid2371858 {
\f13\fs24\cf10\kerning0\insrsid2371858\charrsid3031230 \hich\af13\dbch\af13\loch\f13 Session.configure(bind=engine)
\par \hich\af13\dbch\af13\loch\f13 session = Session()}{\fs24\cf10\kerning0\loch\af13\insrsid2371858\charrsid3031230 
\par }{\fs24\kerning0\loch\af13\insrsid3031230 
\par {\listtext\pard\plain\b\fs20\cf6\lang2052\langfe2052\langnp2052\insrsid3031230\charrsid3031230 \hich\af0\dbch\af13\loch\f13 (\dbch\f13 \'c1\'f9\loch\f13 )\tab}}\pard \ql \fi-420\li420\ri0\nowidctlpar
\jclisttab\tx420\faauto\ls1\rin0\lin420\itap0\pararsid3031230 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3031230\charrsid3031230 \loch\af13\hich\af0\dbch\f13 \'cc\'ed\'bc\'d3\'ca\'fd\'be\'dd}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid3031230\charrsid3031230 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid3031230 {
\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3031230 \loch\af13\hich\af13\dbch\f13 \'b5\'a5\'cc\'f5\'a3\'ba}{\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3031230 \hich\af13\dbch\af13\loch\f13  }{
\fs24\cf10\kerning0\loch\af13\insrsid3031230\charrsid3031230 
\par }{\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3031230 \hich\af13\dbch\af13\loch\f13 ed_user = User('ed', 'Ed Jones', 'edspassword')
\par \hich\af13\dbch\af13\loch\f13 session.add(\hich\af13\dbch\af13\loch\f13 ed_user)
\par }{\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3031230 \loch\af13\hich\af13\dbch\f13 \'b6\'e0\'cc\'f5\'a3\'ba}{\fs24\cf10\kerning0\loch\af13\insrsid3031230\charrsid3031230 
\par }{\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3031230 \hich\af13\dbch\af13\loch\f13  session.add_all([
\par \hich\af13\dbch\af13\loch\f13 ...     User('wendy', 'Wendy Williams', 'foobar'),
\par \hich\af13\dbch\af13\loch\f13 ...     User('mary', 'Mary Contrary', 'xxg527'),
\par \hich\af13\dbch\af13\loch\f13 ...     User('fred', 'Fred Flinstone', 'blah')])
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid8404809 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid8404809\charrsid1011018 
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid3031230 {
\f13\fs24\cf10\kerning0\insrsid3031230\charrsid3810732 \hich\af13\dbch\af13\loch\f13 session.commit()
\par }\pard \ql \li0\ri0\widctlpar\tx916\tx1832\tx2748\tx3664\tx4580\tx5496\tx6412\tx7328\tx8244\tx9160\tx10076\tx10992\tx11908\tx12824\tx13740\tx14656\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0\pararsid3810732 {
\f13\fs24\cf10\kerning0\insrsid3810732\charrsid3810732 \hich\af13\dbch\af13\loch\f13 # close when finished
\par \hich\af13\dbch\af13\loch\f13 session.close()
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid1011018 {\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid1011018 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 
\par 
\par 
\par 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \hich\af0\dbch\af13\loch\f13 P}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \hich\af0\dbch\af13\loch\f13 ylons }{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \loch\af13\hich\af0\dbch\f13 \'ca\'fd\'be\'dd\loch\af13\hich\af0\dbch\f13 \'bf\'e2\loch\af13\hich\af0\dbch\f13 \'b5\'c4\loch\af13\hich\af0\dbch\f13 \'c9\'e8\'d6\'c3}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 
\par 
\par \hich\af0\dbch\af13\loch\f13 1\hich\af0\dbch\af13\loch\f13 .}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \loch\af13\hich\af0\dbch\f13 \'d4\'da}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 development.ini}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \loch\af13\hich\af0\dbch\f13 
\'d6\'d0\loch\af13\hich\af0\dbch\f13 \'c9\'e8\'d6\'c3\loch\af13\hich\af0\dbch\f13 \'ca\'fd\'be\'dd\loch\af13\hich\af0\dbch\f13 \'bf\'e2\loch\af13\hich\af0\dbch\f13 \'b5\'c4\loch\af13\hich\af0\dbch\f13 \'c2\'b7\loch\af13\hich\af0\dbch\f13 \'be\'b6}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 
\par }\pard \ql \li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid14823777 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 # SQLAlchemy database URL
\par \hich\af0\dbch\af13\loch\f13 sqlalchemy.url = sqlite:///%(here)s/development.db}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 
\par }{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 2\hich\af0\dbch\af13\loch\f13 .}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 
\hich\af0\dbch\af13\loch\f13  \hich\af0\dbch\af13\loch\f13 environment.py}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13  }{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \loch\af13\hich\af0\dbch\f13 \'d6\'d0\loch\af13\hich\af0\dbch\f13 \'c9\'e8\'d6\'c3}{
\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 engine}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 \loch\af13\hich\af0\dbch\f13 \'a3\'ac
\loch\af13\hich\af0\dbch\f13 \'b2\'a2\loch\af13\hich\af0\dbch\f13 \'b3\'f5\loch\af13\hich\af0\dbch\f13 \'c8\'e7\loch\af13\hich\af0\dbch\f13 \'bb\'af}{\b\fs20\cf6\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 # Setup SQLAlchemy database engine
\par \hich\af0\dbch\af13\loch\f13     engine = engine_from_config(config, 'sqlalchemy.')
\par }\pard \ql \fi405\li0\ri0\nowidctlpar\faauto\rin0\lin0\itap0\pararsid11172471 {\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777\charrsid14823777 \hich\af0\dbch\af13\loch\f13 init_model(engine)}{
\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid14823777 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11172471 
\par }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11172471 \loch\af13\hich\af0\dbch\f13 \'c8\'e7\loch\af13\hich\af0\dbch\f13 \'b9\'fb}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11172471 
\hich\af0\dbch\af13\loch\f13 D\hich\af0\dbch\af13\loch\f13 B\hich\af0\dbch\af13\loch\f13  }{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11172471 \loch\af13\hich\af0\dbch\f13 \'ce\'c4\'bc\'fe\loch\af13\hich\af0\dbch\f13 \'b2\'bb
\loch\af13\hich\af0\dbch\f13 \'b4\'e6\loch\af13\hich\af0\dbch\f13 \'d4\'da\loch\af13\hich\af0\dbch\f13 \'a3\'ac\loch\af13\hich\af0\dbch\f13 \'b3\'cc\'d0\'f2\loch\af13\hich\af0\dbch\f13 \'bb\'e1\loch\af13\hich\af0\dbch\f13 \'d7\'d4
\loch\af13\hich\af0\dbch\f13 \'b6\'af\loch\af13\hich\af0\dbch\f13 \'d6\'d8\loch\af13\hich\af0\dbch\f13 \'bd\'a8}{\b\fs20\cf10\lang2052\langfe2052\kerning0\loch\af13\langnp2052\insrsid11172471\charrsid14823777 
\par }}